﻿using GodSystemCommon;
using GodSystemModel;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace GodSystemDAL
{
    public class SupplierDAL
    {

        public MySqlDataReader GetSupplierById(SupplierModel supplier)
        {
            string sql = "select Id,SupplierName,Telphone,Phone,Country,Province,City,Area,Address,CreateTime,SupplierStatus,CreateUser " +
                " from Supplier where Id = @Id limit 1";
            MySqlParameter[] pms =
            {
                new MySqlParameter("@Id", supplier.Id)
            };
            return SqlHelper.ExecuteReader(sql, pms);
        }
    }
}
